Odd & Even

The odd and even functions are other forms of rounding functions used in Excel.  To examine these functions, refer to column I on the math tab of the Funexam document. 

The odd function is used to find the next odd number upward from a certain number.  If the number is odd, Excel will specify the same number as the next odd number.  If the number is even, Excel will identify the next odd number.

Skill Builder:  Using the Odd Function

1.	Click	Within the Cell where you want the odd value to appear.

2.	Type	The function equation.  With this function you will use 
		the following.  

		=odd(cell address of the value you would like to change)  

		For example, if you wanted find the next odd value after 
		the value in cell A2, you would use the following formula:         
		=odd(A2)

3.  	Press	Enter.  The value of the nearest odd value above the 
		specified value will appear.

The even function works like the odd function with the exception that the even function will find the next even number instead of the next odd number.  

Skill Builder:  Using the Even Function

1.	Click	Within the Cell where you want the even value to appear.

2.	Type	The function equation.  With this function you will use 
		the following.  

		=even(cell address of the value you would 	like to 
		change)  

		For example, if you wanted find the next even value 
		after the value in cell A2, you would use the following 
		formula:         
		=even(A2)

3.  	Press	Enter.  The value of the nearest even value above the 
		specified value will appear.

Note:  The odd and even functions will show only whole number results.  However, both can evaluate decimal numbers.